{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":50,"n_cols":23,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[null,"Exemplo 5 - Simulação (NPA escolhidosde antemão)"]
[]
[null,"Chegada Exponencial de média",null,null,15]
[null,"Serviço Uniforme de min - máx",null,null,10,15]
[]
[null,"Nº Clientes",5]
[null,null,null,null,null,null,"Próx.",null,"Próx.","Próxima","Próxima","Próximo","Tempo",null,"NPA ","NPA ","Nº","Intervalo","Tempo ","Tempo","Tempo","Tempo","Tempo "]
[null,"Cliente Ch.","Cliente Nº","T. Simul.","Nº Clientes","NPA Ch","Int. CH","NPA Par","T. Serv.","Chegada","Partida","Acontec.","Espera",null,"Chegadas","Seviço","Clientes","Chegadas","Serviço","Chegada","Partida","Fila","Sistema"]
[null,1,{"$f":"SUM($B$9:B9)","v":1},0,1,5.8999999999999997E-2,{"$f":"-$E$3*LN(F9)","v":42.453267526146263},0.67300000000000004,{"$f":"$E$4+H9*($F$4-$E$4)","v":13.365},{"$f":"+D9+G9","v":42.453267526146263},{"$f":"+D9+I9","v":13.365},{"$f":"IF(J9<K9,\"chegada\",\"partida\")","v":"partida"},{"$f":"IF(E9<2,0,(E9-1)*(D10-D9))","v":0},null,5.8999999999999997E-2,0.67300000000000004,1,{"$f":"-$E$3*LN(O9)","v":42.453267526146263},{"$f":"+$E$4+P9*($F$4-$E$4)","v":13.365},0,{"$f":"+T9+S9","v":13.365},{"$f":"+U9-T9-S9","v":0},{"$f":"+U9-T9","v":13.365}]
[null,{"$f":"IF(SUM(E9:L9)=0,0,IF(L9=\"partida\",0,1))","v":0},{"$f":"SUM($B$9:B10)","v":1},{"$f":"IF(L9=\"partida\",K9,J9)","v":13.365},{"$f":"IF(L9=\"partida\",E9-1,E9+1)","v":0},{"$f":"IF(L9=\"partida\", 0,RAND())","v":0},{"$f":"IF(F10=0,0,-$E$3*LN(F10))","v":0},{"$f":"IF(L9=\"partida\",IF(E10=0,0,RAND()),IF(E10>1,0,RAND()))","v":0},{"$f":"IF(H10=0,0,$E$4+H10*($F$4-$E$4))","v":0},{"$f":"IF(C10=$C$6,0,+J9+G10)","v":42.453267526146263},{"$f":"IF(D10<K9,K9,IF(I10=0,0,D10+I10))","v":0},{"$f":"IF(C10<$C$6,IF(C10=$C$6,\"partida\",IF(K10=0,\"chegada\",IF(J10<K10,\"chegada\",\"partida\"))),IF(E10=0,0,IF(C10=$C$6,\"partida\",IF(K10=0,\"chegada\",IF(J10<K10,\"chegada\",\"partida\")))))","v":"chegada"},0,null,0.48,0.94899999999999995,{"$f":"+Q9+1","v":2},{"$f":"-$E$3*LN(O10)","v":11.009537626203006},{"$f":"+$E$4+P10*($F$4-$E$4)","v":14.745000000000001},{"$f":"+R9+T9","v":42.453267526146263},{"$f":"MAX(T10,U9)+S10","v":57.198267526146267},{"$f":"+U10-T10-S10","v":0},{"$f":"+U10-T10","v":14.745000000000005}]
[null,1,{"$f":"SUM($B$9:B11)","v":2},42.453267526146263,{"$f":"IF(L10=\"partida\",E10-1,E10+1)","v":1},{"$f":"IF(L10=\"partida\", 0,0.48)","v":0.48},{"$f":"IF(F11=0,0,-$E$3*LN(F11))","v":11.009537626203006},{"$f":"IF(L10=\"partida\",IF(E11=0,0,0.949),IF(E11>1,0,0.949))","v":0.94899999999999995},{"$f":"IF(H11=0,0,$E$4+H11*($F$4-$E$4))","v":14.745000000000001},53.462805152349269,{"$f":"IF(D11<K10,K10,IF(I11=0,0,D11+I11))","v":57.198267526146267},"chegada",0,null,0.61399999999999999,0.59299999999999997,{"$f":"+Q10+1","v":3},{"$f":"-$E$3*LN(O11)","v":7.3164052625249187},{"$f":"+$E$4+P11*($F$4-$E$4)","v":12.965},{"$f":"+R10+T10","v":53.462805152349269},{"$f":"MAX(T11,U10)+S11","v":70.163267526146271},{"$f":"+U11-T11-S11","v":3.7354623737970023},{"$f":"+U11-T11","v":16.700462373797002}]
[null,1,{"$f":"SUM($B$9:B12)","v":3},53.462805152349269,{"$f":"IF(L11=\"partida\",E11-1,E11+1)","v":2},{"$f":"IF(L11=\"partida\", 0,0.614)","v":0.61399999999999999},7.3164052625249187,{"$f":"IF(L11=\"partida\",IF(E12=0,0,RAND()),IF(E12>1,0,RAND()))","v":0},{"$f":"IF(H12=0,0,$E$4+H12*($F$4-$E$4))","v":0},60.779210414874186,57.198267526146267,"partida",3.7354623737969987,null,0.93400000000000005,0.17799999999999999,{"$f":"+Q11+1","v":4},{"$f":"-$E$3*LN(O12)","v":1.0241826112994157},{"$f":"+$E$4+P12*($F$4-$E$4)","v":10.89},{"$f":"+R11+T11","v":60.779210414874186},{"$f":"MAX(T12,U11)+S12","v":81.053267526146271},{"$f":"+U12-T12-S12","v":9.3840571112720852},{"$f":"+U12-T12","v":20.274057111272086}]
[null,0,{"$f":"SUM($B$9:B13)","v":3},57.198267526146267,{"$f":"IF(L12=\"partida\",E12-1,E12+1)","v":1},{"$f":"IF(L12=\"partida\", 0,RAND())","v":0},0,{"$f":"IF(L12=\"partida\",IF(E13=0,0,0.593),IF(E13>1,0,0.593))","v":0.59299999999999997},12.965,60.779210414874186,70.163267526146271,"chegada",0,null,0.23799999999999999,0.34699999999999998,{"$f":"+Q12+1","v":5},{"$f":"-$E$3*LN(O13)","v":21.532269079659937},{"$f":"+$E$4+P13*($F$4-$E$4)","v":11.734999999999999},{"$f":"+R12+T12","v":61.803393026173602},{"$f":"MAX(T13,U12)+S13","v":92.788267526146271},{"$f":"+U13-T13-S13","v":19.24987449997267},{"$f":"+U13-T13","v":30.984874499972669}]
[null,1,{"$f":"SUM($B$9:B14)","v":4},60.779210414874186,{"$f":"IF(L13=\"partida\",E13-1,E13+1)","v":2},{"$f":"IF(L13=\"partida\", 0,0.934)","v":0.93400000000000005},1.0241826112994157,{"$f":"IF(L13=\"partida\",IF(E14=0,0,RAND()),IF(E14>1,0,RAND()))","v":0},0,61.803393026173602,70.163267526146271,"chegada",1.0241826112994161]
[null,1,{"$f":"SUM($B$9:B15)","v":5},61.803393026173602,{"$f":"IF(L14=\"partida\",E14-1,E14+B15)","v":3},{"$f":"IF(C15=$C$6,0, RAND())","v":0},0,{"$f":"IF(L14=\"partida\",IF(E15=0,0,RAND()),IF(E15>1,0,RAND()))","v":0},0,0,70.163267526146271,"partida",16.719748999945338]
[null,0,{"$f":"SUM($B$9:B16)","v":5},70.163267526146271,{"$f":"IF(L15=\"partida\",E15-1,E15+B16)","v":2},0,0,{"$f":"IF(L15=\"partida\",IF(E16=0,0,0.178),IF(E16>1,0,0.178))","v":0.17799999999999999},10.89,0,81.053267526146271,{"$f":"IF(C16<$C$6,IF(C16=$C$6,\"partida\",IF(K16=0,\"chegada\",IF(J16<K16,\"chegada\",\"partida\"))),IF(E16=0,0,IF(C16=$C$6,\"partida\",IF(K16=0,\"chegada\",IF(J16<K16,\"chegada\",\"partida\")))))","v":"partida"},10.89]
[null,0,{"$f":"SUM($B$9:B17)","v":5},81.053267526146271,1,0,0,{"$f":"IF(L16=\"partida\",IF(E17=0,0,0.347),IF(E17>1,0,0.347))","v":0.34699999999999998},11.734999999999999,0,92.788267526146271,{"$f":"IF(C17<$C$6,IF(C17=$C$6,\"partida\",IF(K17=0,\"chegada\",IF(J17<K17,\"chegada\",\"partida\"))),IF(E17=0,0,IF(C17=$C$6,\"partida\",IF(K17=0,\"chegada\",IF(J17<K17,\"chegada\",\"partida\")))))","v":"partida"},0]
[null,0,{"$f":"SUM($B$9:B18)","v":5},92.788267526146271,0,0,0,{"$f":"IF(L17=0,0,IF(L17=\"partida\",IF(E18=0,0,RAND()),IF(E18>1,0,RAND())))","v":0},0,0,0,{"$f":"IF(C18<$C$6,IF(C18=$C$6,\"partida\",IF(K18=0,\"chegada\",IF(J18<K18,\"chegada\",\"partida\"))),IF(E18=0,0,IF(C18=$C$6,\"partida\",IF(K18=0,\"chegada\",IF(J18<K18,\"chegada\",\"partida\")))))","v":0},0]
[null,0,{"$f":"SUM($B$9:B19)","v":5},0,0,0,0,{"$f":"IF(L18=0,0,IF(L18=\"partida\",IF(E19=0,0,RAND()),IF(E19>1,0,RAND())))","v":0},0,0,0,{"$f":"IF(C19<$C$6,IF(C19=$C$6,\"partida\",IF(K19=0,\"chegada\",IF(J19<K19,\"chegada\",\"partida\"))),IF(E19=0,0,IF(C19=$C$6,\"partida\",IF(K19=0,\"chegada\",IF(J19<K19,\"chegada\",\"partida\")))))","v":0},0]
[null,0,{"$f":"SUM($B$9:B20)","v":5},0,0,0,0,{"$f":"IF(L19=0,0,IF(L19=\"partida\",IF(E20=0,0,RAND()),IF(E20>1,0,RAND())))","v":0},0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B21)","v":5},0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B22)","v":5},0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B23)","v":5},0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B24)","v":5},0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B25)","v":5},0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B26)","v":5},0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B27)","v":5},0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B28)","v":5},0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B29)","v":5},0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B30)","v":5},{"$f":"IF(L29=\"partida\",K29,J29)","v":0},{"$f":"IF(L29=\"partida\",E29-1,E29+B30)","v":0},{"$f":"IF(C30=$C$6,0, RAND())","v":0},0,{"$f":"IF(L29=0,0,IF(L29=\"partida\",IF(E30=0,0,RAND()),IF(E30>1,0,RAND())))","v":0},0,{"$f":"IF(C30=$C$6,0,+J29+G30)","v":0},{"$f":"IF(D30<K29,K29,IF(I30=0,0,D30+I30))","v":0},{"$f":"IF(C30<$C$6,IF(C30=$C$6,\"partida\",IF(K30=0,\"chegada\",IF(J30<K30,\"chegada\",\"partida\"))),IF(E30=0,0,IF(C30=$C$6,\"partida\",IF(K30=0,\"chegada\",IF(J30<K30,\"chegada\",\"partida\")))))","v":0},{"$f":"IF(E30<2,0,(E30-1)*(D31-D30))","v":0}]
[null,0,{"$f":"SUM($B$9:B31)","v":5},{"$f":"IF(L30=\"partida\",K30,J30)","v":0},{"$f":"IF(L30=\"partida\",E30-1,E30+B31)","v":0},{"$f":"IF(C31=$C$6,0, RAND())","v":0},0,{"$f":"IF(L30=0,0,IF(L30=\"partida\",IF(E31=0,0,RAND()),IF(E31>1,0,RAND())))","v":0},0,{"$f":"IF(C31=$C$6,0,+J30+G31)","v":0},{"$f":"IF(D31<K30,K30,IF(I31=0,0,D31+I31))","v":0},{"$f":"IF(C31<$C$6,IF(C31=$C$6,\"partida\",IF(K31=0,\"chegada\",IF(J31<K31,\"chegada\",\"partida\"))),IF(E31=0,0,IF(C31=$C$6,\"partida\",IF(K31=0,\"chegada\",IF(J31<K31,\"chegada\",\"partida\")))))","v":0},{"$f":"IF(E31<2,0,(E31-1)*(D32-D31))","v":0}]
[null,0,{"$f":"SUM($B$9:B32)","v":5},{"$f":"IF(L31=\"partida\",K31,J31)","v":0},{"$f":"IF(L31=\"partida\",E31-1,E31+B32)","v":0},{"$f":"IF(C32=$C$6,0, RAND())","v":0},0,{"$f":"IF(L31=0,0,IF(L31=\"partida\",IF(E32=0,0,RAND()),IF(E32>1,0,RAND())))","v":0},0,{"$f":"IF(C32=$C$6,0,+J31+G32)","v":0},{"$f":"IF(D32<K31,K31,IF(I32=0,0,D32+I32))","v":0},{"$f":"IF(C32<$C$6,IF(C32=$C$6,\"partida\",IF(K32=0,\"chegada\",IF(J32<K32,\"chegada\",\"partida\"))),IF(E32=0,0,IF(C32=$C$6,\"partida\",IF(K32=0,\"chegada\",IF(J32<K32,\"chegada\",\"partida\")))))","v":0},{"$f":"IF(E32<2,0,(E32-1)*(D33-D32))","v":0}]
[null,0,{"$f":"SUM($B$9:B33)","v":5},{"$f":"IF(L32=\"partida\",K32,J32)","v":0},{"$f":"IF(L32=\"partida\",E32-1,E32+B33)","v":0},{"$f":"IF(C33=$C$6,0, RAND())","v":0},{"$f":"-15*LN(1-F33)","v":0},{"$f":"IF(L32=0,0,IF(L32=\"partida\",IF(E33=0,0,RAND()),IF(E33>1,0,RAND())))","v":0},0,{"$f":"IF(C33=$C$6,0,+J32+G33)","v":0},{"$f":"IF(D33<K32,K32,IF(I33=0,0,D33+I33))","v":0},{"$f":"IF(C33<$C$6,IF(C33=$C$6,\"partida\",IF(K33=0,\"chegada\",IF(J33<K33,\"chegada\",\"partida\"))),IF(E33=0,0,IF(C33=$C$6,\"partida\",IF(K33=0,\"chegada\",IF(J33<K33,\"chegada\",\"partida\")))))","v":0},{"$f":"IF(E33<2,0,(E33-1)*(D34-D33))","v":0}]
[]
[]
[null,null,null,null,"Medidas de Performance",null,null,null,null,null,null,null,null,null,null,null,null,"Medidas de Performance"]
[]
[null,null,"Tempo Total de Simulação",null,null,null,{"$f":"MAX(D9:D33)","v":92.788267526146271},"minutos",null,null,null,null,null,null,null,"Tempo Total de Simulação",null,null,null,null,{"$f":"MAX(U9:U33)","v":92.788267526146271},"minutos"]
[null,null,"Tempo de Actividade (Serviço)",null,null,null,{"$f":"SUM(I9:I33)","v":63.7},"\"",null,null,null,null,null,null,null,"Tempo Total de Actividade (Serviço)",null,null,null,null,{"$f":"SUM(S9:S33)","v":63.7},"\""]
[null,null,"Tempo Total na Fila",null,null,null,{"$f":"SUM(M9:M33)","v":32.369393985041754},"\"",null,null,null,null,null,null,null,"Tempo Total na Fila",null,null,null,null,{"$f":"SUM(V9:V9:V33)","v":32.369393985041754},"\""]
[null,null,"Tempo no Sistema",null,null,null,{"$f":"+G40+G39","v":96.069393985041756},"\"",null,null,null,null,null,null,null,"Tempo Total no Sistema",null,null,null,null,{"$f":"SUM(W9:W10:W33)","v":96.069393985041756},"\""]
[null,null,"Tempo de Inactividade",null,null,null,{"$f":"G38-G39","v":29.088267526146268},"\"",null,null,null,null,null,null,null,"Tempo Total de Inactividade",null,null,null,null,{"$f":"+U38-U39","v":29.088267526146268},"\""]
[]
[null,null,"Comprimento médio da Fila",null,null,null,{"$f":"+G40/MAX(D9:D33)","v":0.34885222936100807},"clientes",null,null,null,null,null,null,null,"Compriento médio fila",null,null,null,null,{"$f":"+U40/U38","v":0.34885222936100807},"clientes"]
[null,null,"Nº médio clientes no Sistema",null,null,null,{"$f":"+G41/MAX(D9:D33)","v":1.0353614368106498},"\"",null,null,null,null,null,null,null,"Nº médio Clientes no Sistema",null,null,null,null,{"$f":"+U41/U38","v":1.0353614368106498},"\""]
[null,null,"Tempo médio na Fila",null,null,null,{"$f":"+G40/MAX(C9:C33)","v":6.4738787970083509},"\"",null,null,null,null,null,null,null,"Tempo médio na fila",null,null,null,null,{"$f":"+U40/MAX(Q9:Q33)","v":6.4738787970083509},"minutos"]
[null,null,"Tempo médio no Sistema",null,null,null,{"$f":"+G41/MAX(C9:C33)","v":19.213878797008352},"\"",null,null,null,null,null,null,null,"Tempo médio no Sistema",null,null,null,null,{"$f":"+U41/MAX(Q9:Q33)","v":19.213878797008352},"\""]
[]
[null,null,"% Utilização média do Serviço",null,null,null,{"$f":"+G39/G38*100","v":68.650920744964168}," %",null,null,null,null,null,null,null,"%Utilização do Sistema",null,null,null,null,{"$f":"+U39/U38*100","v":68.650920744964168},"%"]
[null,null,"% Inactividade do Sistema",null,null,null,{"$f":"+G42/G38*100","v":31.349079255035829},"%",null,null,null,null,null,null,null,"% Inactividade do Sistema",null,null,null,null,{"$f":"+U42/U38*100","v":31.349079255035829},"%"]

{"sheet":"Sheet2","index":1,"n_rows":105,"n_cols":31,"rows_kept":105,"cut":false,"hidden":false,"merged":[]}
[null,"Exemplo 5 - Simulação"]
[]
[null,null,null,null,null,null,null,null,null,null,"Unidade: minuto",null,null,null,null,null,null,null,null,null,"Medidas  de Performance : 100 Runs"]
[null,null,null,"média","min",null,"max","NPA","NPA","Nº Clientes","Intervalo","Tempo","Tempo","Tempo","Tempo ","Tempo",null,null,"M1","M2","M3","M4","M5","M6","M7","M8","M9","M10","M11","M12","M13"]
[null,null,null,null,null,null,null,"Cheg","Serv",null,"Chegadas","Serviço","Chegada","Partida","Fila","Sistema",null,null,{"$f":"+G10","v":1264.7920644726237},{"$f":"+G11","v":2384.4862391811012},{"$f":"+G12","v":3649.2783036537239},{"$f":"+G13","v":282.17812290114261},{"$f":"+G14","v":1546.9701873737663},{"$f":"+G15","v":100},{"$f":"+G17","v":1.541391203685156},{"$f":"+G18","v":2.3589842476854503},{"$f":"+G19","v":23.844862391811013},{"$f":"+G20","v":36.49278303653724},{"$f":"+G21","v":12.647920644726236},{"$f":"+G23","v":18.24069559997054},{"$f":"+G24","v":81.759304400029464}]
[null,"Exponencial",null,15,null,null,null,{"$f":"RAND()","v":4.4176353367424759E-2},{"$f":"RAND()","v":0.53554730568258535},1,{"$f":"-$D$6*LN(1-H6)","v":0.67772779495553404},{"$f":"+$E$7+I6*($G$7-$E$7)","v":12.677736528412927},0,{"$f":"+M6+L6","v":12.677736528412927},{"$f":"+N6-M6-L6","v":0},{"$f":"+N6-M6","v":12.677736528412927},null,1,1234.5893721627858,1597.7389597754029,2832.3283319381894,401.11505422074629,1635.7044263835321,100,0.97678953116727263,1.7315648758133755,15.97738959775403,28.323283319381893,12.345893721627858,24.522465535389752,75.477534464610258]
[null,"Uniforme",null,null,10,null,15,{"$f":"RAND()","v":0.54509324894411337},0.67096074515280191,{"$f":"+J6+1","v":2},11.814942356537005,{"$f":"+$E$7+I7*($G$7-$E$7)","v":13.354803725764009},{"$f":"+M6+K6","v":0.67772779495553404},{"$f":"MAX(M7,N6)+L7","v":26.032540254176936},{"$f":"+N7-M7-L7","v":12.000008733457394},{"$f":"+N7-M7","v":25.354812459221403},null,{"$f":"+R6+1","v":2},1222.3401457437417,1443.4811165414158,2665.8212622851574,476.621070011857,1698.9612157555987,100,0.84962570254991943,1.5690889453880534,14.434811165414157,26.658212622851575,12.223401457437417,28.0536757161866,71.946324283813397]
[null,null,null,null,null,null,null,0.28797705755316516,6.4863317187931591E-2,{"$f":"+J7+1","v":3},5.0946771832741007,10.324316585939657,{"$f":"+M7+K7","v":12.492670151492538},{"$f":"MAX(M8,N7)+L8","v":36.356856840116592},13.539870102684395,23.864186688624052,null,{"$f":"+R7+1","v":3},1287.8137865674853,2365.6868819962019,3653.5006685636872,182.64502411674835,1470.4588106842336,100,1.6088086689727821,2.4845991210482401,23.656868819962018,36.535006685636873,12.878137865674853,12.4209547924542,87.579045207545803]
[null,null,null,null,"Média",null," Run 0",0.25966253031293451,0.99967889457296033,4,4.5097373493143431,14.998394472864803,17.58734733476664,51.355251312981395,18.769509505349951,33.767903978214754,null,4,1227.5102760119894,1733.3151243682878,2960.8254003802749,325.96522959235449,1553.4755056043439,100,1.1157659828656143,1.9059363277365831,17.333151243682877,29.608254003802749,12.275102760119895,20.982965512902968,79.017034487097021]
[null,"Tempo Total de Actividade (Serviço)",null,"M1",{"$f":"AVERAGE(S5:S105)","v":1250.8470636837669},null,{"$f":"SUM(L6:L5055)","v":1264.7920644726237},0.59933204976437715,9.9315564571569759E-2,5,13.719333734657098,10.496577822857848,22.097084684080983,61.851829135839239,29.258166628900408,39.754744451758256,null,5,1275.2592679965128,4619.9274495409363,5895.1867175374491,165.99241031480346,1441.2516783113163,100,3.205496665893917,4.0903242690025614,46.199274495409362,58.951867175374488,12.752592679965128,11.517239689135572,88.482760310864421]
[null,"Tempo Total na Fila",null,"M2",{"$f":"AVERAGE(T5:T105)","v":2379.766021738752},null,{"$f":"SUM(O6:O5055)","v":2384.4862391811012},0.35850868188641649,0.94637099583552586,6,6.6593944311881819,14.73185497917763,35.816418418738081,76.583684115016865,26.035410717101154,40.767265696278784,null,6,1249.3085933428929,2690.249013272944,3939.557606615836,172.709664306577,1422.0182576494699,100,1.8918526529468058,2.7703987522127469,26.90249013272944,39.395576066158362,12.493085933428929,12.145390073405812,87.854609926594179]
[null,"Tempo Total no Sistema",null,"M3",{"$f":"AVERAGE(U5:U105)","v":3630.6130854225212},null,{"$f":"SUM(P6:P5055)","v":3649.2783036537239},0.7338499925574945,0.63608582808629899,7,19.855427870996941,13.180429140431496,42.475812849926264,89.764113255448365,34.107871265090608,47.288300405522101,null,7,1286.8430231913103,5886.295894932694,7173.1389181240065,161.70709648863522,1448.5501196799455,100,4.0635776525518219,4.9519438924963799,58.862958949326938,71.731389181240061,12.868430231913102,11.163376005544364,88.836623994455636]
[null,"Tempo Total de Inactividade",null,"M4",{"$f":"AVERAGE(V5:V105)","v":295.95669154988212},null,{"$f":"+G14-G10","v":282.17812290114261},0.26466717087708791,0.99106723132279895,8,4.6114808028995524,14.955336156613996,62.331240720923205,104.71944941206236,27.43287253452516,42.388208691139155,null,8,1248.2705993832333,2664.5239629463231,3912.7945623295577,249.52557059906826,1497.7961699823015,100,1.7789629966658334,2.6123678513450814,26.64523962946323,39.127945623295574,12.482705993832333,16.659514532075264,83.340485467924736]
[null,"Tempo Total de Simulação",null,"M5",{"$f":"AVERAGE(W5:W105)","v":1546.8037552336486},null,{"$f":"+MAX(N6:N5055)","v":1546.9701873737663},0.53984576093203418,0.10786927879766572,9,11.642903150678885,10.539346393988328,66.942721523822755,115.25879580605068,37.776727888239606,48.31607428222793,null,9,1255.9031001611256,2890.0236333478565,4145.9267335089826,195.63553778504547,1451.5386379461711,100,1.9910070306065324,2.8562289870390143,28.900236333478563,41.459267335089827,12.559031001611256,13.477804356751847,86.522195643248153]
[null,"Nº Clientes",null,"M6",{"$f":"AVERAGE(X5:X105)","v":100},null,{"$f":"MAX(J6:J105)","v":100},0.7519604749014821,0.9104856509586291,10,20.91250755178222,14.552428254793146,78.585624674501645,129.81122406084384,36.673171131549054,51.225599386342196,null,10,1227.4721828312715,938.20548036681669,2165.6776631980874,460.06096471015053,1687.5331475414221,100,0.55596269722683334,1.2833393325359428,9.3820548036681668,21.656776631980875,12.274721828312716,27.262336469089,72.737663530911007]
[null,null,null,null,null,null,null,0.24343033034429273,0.61668139332371164,11,4.1844098291122318,13.083406966618558,99.498132226283872,142.8946310274624,30.313091834559966,43.396498801178524,null,11,1272.2129067390813,3116.4035851219487,4388.6164918610311,229.83069615499676,1502.043602894078,100,2.0747757116487069,2.9217637113897483,31.164035851219488,43.886164918610312,12.722129067390814,15.301200025895925,84.698799974104077]
[null,"Comprimento médio fila",null,"M7",{"$f":"AVERAGE(Y5:Y105)","v":1.6002513726082483},null,{"$f":"+G11/G14","v":1.541391203685156},0.93482126364504425,6.6370705967905286E-2,12,40.959329891498214,10.331853529839526,103.6825420553961,153.22648455730192,39.21208897206629,49.543942501905818,null,12,1268.4546841861102,2762.81618193234,4031.2708661184506,241.78800514354634,1510.2426893296565,100,1.8293855692548704,2.6692867938382734,27.628161819323399,40.312708661184509,12.684546841861101,16.009877541659712,83.990122458340295]
[null,"Nº médio Cl. Sistema",null,"M8",{"$f":"AVERAGE(Z5:Z105)","v":2.4158409558739602},null,{"$f":"+G12/G14","v":2.3589842476854503},0.80762146666543189,0.4904012581221926,13,24.724354801206424,12.452006290610964,144.6418719468943,165.67849084791288,8.5846126104076212,21.036618901018585,null,13,1241.5889582010484,1658.3043100083414,2899.8932682093891,231.04846153144013,1472.6374197324885,100,1.1260778028508742,1.9691834726949748,16.583043100083415,28.998932682093891,12.415889582010484,15.68943301558989,84.310566984410102]
[null,"Tempo médio na fila",null,"M9",{"$f":"AVERAGE(AA5:AA105)","v":23.797660217387545},null,{"$f":"+G11/G15","v":23.844862391811013},0.38783599634628774,0.83987839678936393,14,7.3613257881549581,14.199391983946819,169.36622674810073,183.56561873204754,0,14.199391983946811,null,14,1240.2829130506666,2585.0926773353917,3825.3755903860583,363.26705294852763,1603.5499659991942,100,1.6121060971895469,2.3855668183076628,25.850926773353919,38.253755903860586,12.402829130506666,22.653927888188434,77.346072111811566]
[null,"Tempo médio no Sistema",null,"M10",{"$f":"AVERAGE(AB5:AB105)","v":36.306130854225195},null,{"$f":"+G12/G15","v":36.49278303653724},0.67321884500919915,0.20863399669387728,15,16.776968743887331,11.043169983469387,176.7275525362557,194.60878871551694,6.8380661957918498,17.881236179261236,null,15,1247.0166942065384,3151.3339316135321,4398.3506258200678,243.77650005783607,1490.7931942643745,100,2.1138639106603545,2.9503425711507991,31.513339316135319,43.983506258200677,12.470166942065385,16.35213395095532,83.64786604904468]
[null,"Tempo médio no Serviço",null,"M11",{"$f":"AVERAGE(AC5:AC105)","v":12.508470636837663},null,{"$f":"+G10/G15","v":12.647920644726236},0.88640845215259878,0.65276926237986543,16,32.627192673222865,13.263846311899327,193.50452128014302,207.87263502741627,1.1042674353739148,14.368113747273242,null,16,1253.5413083367548,1389.2126473587509,2642.753955695508,262.33210445653526,1515.8734127932901,100,0.91644370541393549,1.7433869697771944,13.89212647358751,26.427539556955079,12.535413083367548,17.305673563674265,82.694326436325738]
[null,null,null,null,null,null,null,0.80101734074853048,0.54199981667214259,17,24.218063962415368,12.709999083360714,226.13171395336587,238.84171303672659,0,12.709999083360714,null,17,1231.020394629023,1756.2045862664841,2987.2249808955085,284.2839567381011,1515.3043513671241,100,1.1589781186083292,1.9713696315861573,17.562045862664842,29.872249808955086,12.31020394629023,18.760848702217281,81.239151297782712]
[null,"% Inactividade do Sistema",null,"M12",{"$f":"AVERAGE(AD5:AD105)","v":18.441041673428877},null,{"$f":"+G13/G14*100","v":18.24069559997054},0.25746995659036687,0.67855847179988638,18,4.4653791992896652,13.392792358999433,250.34977791578123,263.74257027478069,2.4868995751603507E-14,13.392792358999458,null,18,1224.5540477078428,1978.2786974348135,3202.8327451426544,301.6177048909708,1526.1717525988136,100,1.2962359538276986,2.0986057039050614,19.782786974348134,32.028327451426541,12.245540477078428,19.763024992263592,80.236975007736405]
[null,"%Utilização do Sistema",null,"M13",{"$f":"AVERAGE(AE5:AE105)","v":81.558958326571144},null,{"$f":"+G10/G14*100","v":81.759304400029464},0.99251118406836158,0.26948637955033106,19,73.415168707704552,11.347431897751655,254.81515711507089,275.09000217253237,8.9274131597098219,20.274845057461476,null,19,1232.3615034457539,3272.0677753648829,4504.4292788106413,56.582420867709516,1288.9439243134634,100,2.5385648775277021,3.4946665978582878,32.720677753648829,45.044292788106411,12.323615034457539,4.3898279669417963,95.610172033058205]
[null,null,null,null,null,null,null,0.61852567788837798,0.88898091665515333,20,14.45567607337591,14.444904583275767,328.23032582277546,342.67523040605124,1.9539925233402755E-14,14.444904583275786,null,20,1258.703628481637,1662.5769726529234,2921.2806011345601,349.46868073105293,1608.1723092126899,100,1.0338301207703722,1.8165221378328087,16.625769726529235,29.212806011345602,12.587036284816371,21.730798293756326,78.269201706243678]
[null,null,null,null,null,null,null,0.48888694953639023,5.1265551507985507E-2,21,10.06746719194568,10.256327757539928,342.68600189615137,352.94232965369127,-2.1316282072803006E-14,10.256327757539907,null,21,1247.9524646514496,1406.817946462184,2654.7704111136318,435.62947771300264,1683.5819423644523,100,0.83561002352307479,1.5768584494231539,14.06817946462184,26.547704111136319,12.479524646514497,25.875157409991989,74.124842590008015]
[null,null,null,null,null,null,null,0.85483872762751334,0.40761143446910519,22,28.948648970476246,12.038057172345527,352.75346908809706,364.98038682603681,0.18886056559421682,12.226917737939743,null,22,1263.0867585554429,1278.453685749904,2541.5404443053462,539.17198809791194,1802.2587466533548,100,0.70936189829783691,1.4101973143560969,12.78453685749904,25.415404443053461,12.630867585554428,29.916458394173954,70.083541605826042]
[null,"Nº de Runs = 101",null,null,null,null,null,0.90981938574066001,0.27150380666477114,23,36.089111917973717,11.357519033323856,381.70211805857332,393.05963709189717,0,11.357519033323854,null,23,1245.8519578665939,2809.9861840347494,4055.8381419013417,276.60720345987806,1522.459161326472,100,1.845689037456016,2.6640045558710517,28.099861840347494,40.558381419013415,12.458519578665939,18.168448158496332,81.831551841503668]
[null,null,null,null,null,null,null,0.5109723434207496,0.37090536787749007,24,10.730043505271937,11.85452683938745,417.79122997654702,429.64575681593448,0,11.854526839387461,null,24,1253.2377819311259,5243.7613255857195,6496.9991075168455,106.61551324743004,1359.853295178556,100,3.856122821614508,4.77772060453312,52.437613255857194,64.969991075168451,12.532377819311259,7.8402217081388077,92.159778291861187]
[null,null,null,null,null,null,null,0.29569048675075837,4.9011463721971849E-3,25,5.2580605490978343,10.024505731860986,428.52127348181898,439.67026254779546,1.1244833341154941,11.14898906597648,null,25,1236.4597689010029,1488.529701316003,2724.9894702170068,281.03395272236071,1517.4937216233636,100,0.98091325196629087,1.795717129756494,14.885297013160029,27.249894702170067,12.364597689010029,18.519612220979738,81.480387779020262]
[null,null,null,null,null,null,null,0.85256764837270305,0.36290003316816422,26,28.715787621627541,11.814500165840821,433.7793340309168,451.48476271363626,5.8909285168786365,17.705428682719457,null,26,1292.4295598460935,2432.1844214159159,3724.6139812620081,213.93366063002713,1506.3632204761207,100,1.6146068812322492,2.4725869104031619,24.32184421415916,37.246139812620079,12.924295598460935,14.20199708290863,85.798002917091381]
[null,null,null,null,null,null,null,0.63283474394763961,0.84911258973040682,27,15.029148649593195,14.245562948652033,462.49512165254436,476.74068460119639,0,14.245562948652037,null,27,1238.7418101922226,2430.0637191983833,3668.8055293906073,329.20192988027497,1567.9437400724976,100,1.5498411435897717,2.3398833999113844,24.300637191983832,36.688055293906075,12.387418101922226,20.99577436783883,79.004225632161166]
[null,null,null,null,null,null,null,0.91806764725618217,0.94746015522345017,28,37.527920080932766,14.737300776117252,477.52427030213755,492.2615710782548,0,14.737300776117252,null,28,1238.5600762876886,1121.6955145882978,2360.255590875985,563.47644881206611,1802.0365250997547,100,0.62245992185214138,1.3097712271649595,11.216955145882977,23.60255590875985,12.385600762876885,31.268869468718119,68.731130531281877]
[null,null,null,null,null,null,null,0.88932635324210552,0.18262999840875327,29,33.017542914139185,10.913149992043767,515.0521903830703,525.96534037511401,-5.3290705182007514E-14,10.913149992043714,null,29,1262.5590334900742,2200.3775262174031,3462.9365597074784,143.76919270815097,1406.3282261982251,100,1.5646258712774033,2.4623956877186148,22.003775262174031,34.629365597074781,12.625590334900743,10.223018355878919,89.776981644121079]
[null,null,null,null,null,null,null,{"$f":"RAND()","v":4.278880149411024E-2},{"$f":"RAND()","v":0.13517490974616142},30,0.65596835674934029,10.675874548730807,548.0697332972095,558.7456078459403,0,10.675874548730803,null,30,1269.7053329559681,4717.4894232676925,5987.1947562236574,28.554206658224757,1298.2595396141928,100,3.6337028762905152,4.6117086557306468,47.174894232676927,59.871947562236571,12.697053329559681,2.1994220559866084,97.800577944013384]
[null,null,null,null,null,null,null,{"$f":"RAND()","v":0.99470113793062076},0.9888721743873724,{"$f":"+J35+1","v":31},78.603947780504257,{"$f":"+$E$7+I36*($G$7-$E$7)","v":14.944360871936862},{"$f":"+M35+K35","v":548.72570165395882},{"$f":"MAX(M36,N35)+L36","v":573.68996871787715},{"$f":"+N36-M36-L36","v":10.019906191981466},{"$f":"+N36-M36","v":24.964267063918328},null,31,1218.8801489531049,1018.7215009862339,2237.601649939339,335.93704315618152,1554.8171921092865,100,0.65520339378562065,1.4391413095347743,10.187215009862339,22.376016499393391,12.18880148953105,21.60620842508467,78.393791574915326]
[null,null,null,null,null,null,null,0.7349052254747912,0.98163011189686633,32,19.915018158239782,14.908150559484332,627.32964943446314,642.23779999394742,-4.7961634663806763E-14,14.908150559484284,null,32,1248.2544490172695,2645.1870736494047,3893.4415226666742,98.939931703522234,1347.1943807207917,100,1.9634784048268861,2.890036937790343,26.451870736494048,38.934415226666744,12.482544490172694,7.3441467036543182,92.655853296345683]
[null,null,null,null,null,null,null,0.14102044805099756,0.77264306049773934,33,{"$f":"-$D$6*LN(1-H38)","v":2.2801524264649493},13.863215302488697,647.24466759270297,661.10788289519166,0,13.863215302488697,null,33,1254.0416420478487,1639.9158835905832,2893.9575256384328,539.95653461891425,1793.9981766667629,100,0.91411234689075127,1.6131329247030715,16.399158835905833,28.939575256384327,12.540416420478486,30.097942218768026,69.902057781231974]
[null,null,null,null,null,null,null,0.78224140272851062,0.48003678291300755,34,22.865522725888191,12.400183914565037,649.52482001916792,673.50806680975666,11.5830628760237,23.983246790588737,null,34,1254.0637373837626,3550.4659501833912,4804.5296875671575,381.92491643516632,1635.9886538189289,100,2.1702265122043789,2.9367744552212049,35.504659501833913,48.045296875671575,12.540637373837626,23.345205698317621,76.654794301682387]
[null,null,null,null,null,null,null,0.35310319562151105,0.89781510031866862,35,6.5335274376706414,14.489075501593344,672.39034274505616,687.99714231134999,1.1177240647004858,15.60679956629383,null,35,1260.2799608084772,2012.2700775345695,3272.5500383430467,331.31963178244609,1591.5995925909233,100,1.2643067307266946,2.0561390274143938,20.122700775345695,32.725500383430465,12.602799608084773,20.816770331230078,79.183229668769926]
[null,null,null,null,null,null,null,0.29336219774599048,0.42140533337427877,36,5.2085557002805709,12.107026666871395,678.92387018272677,700.10416897822142,9.0732721286232554,21.18029879549465,null,36,1249.7698090460619,2205.9164618885388,3455.6862709345978,268.3644466005328,1518.1342556465947,100,1.4530443889819271,2.2762718501880932,22.05916461888539,34.556862709345978,12.49769809046062,17.677253879383194,82.322746120616813]
[null,null,null,null,null,null,null,0.95439181902991521,0.10583734970338921,37,46.315022569719737,10.529186748516945,684.13242588300739,710.63335572673839,15.971743095214055,26.500929843731001,null,37,1236.4883338045017,2327.2584510198349,3563.7467848243368,359.75990795042685,1596.2482417549286,100,1.4579552165778598,2.2325767957660045,23.27258451019835,35.637467848243368,12.364883338045017,22.537842081185559,77.462157918814441]
[null,null,null,null,null,null,null,0.13241433318856699,0.77180629972637949,38,2.1306153100360801,13.859031498631897,730.44744845272714,744.30647995135905,0,13.859031498631907,null,38,1254.0298214297109,3228.499079871468,4482.5289013011761,224.08607489999531,1478.1158963297062,100,2.1841988763452984,3.0325963697648444,32.284990798714681,44.825289013011762,12.540298214297108,15.160250658045221,84.839749341954771]
[null,null,null,null,null,null,null,0.3893063599983172,0.39257505910059598,39,7.3973977962482698,11.962875295502979,732.57806376276324,756.26935524686201,11.728416188595791,23.69129148409877,null,39,1242.2043451219922,2276.6082991208841,3518.812644242877,302.48915624176584,1544.6935013637581,100,1.4738252586101663,2.2780005490644166,22.76608299120884,35.188126442428768,12.422043451219922,19.582470954575022,80.41752904542497]
[null,null,null,null,null,null,null,0.93853077303045196,0.54436524183065493,40,41.838279058164666,12.721826209153274,739.97546155901148,768.99118145601528,16.293893687850531,29.015719897003805,null,40,1236.0842990960339,2861.9865763596522,4098.0708754556863,70.392138083103418,1306.4764371791373,100,2.1906147672583178,3.1367353890468825,28.619865763596522,40.980708754556865,12.360842990960339,5.3879378211435442,94.612062178856462]
[null,null,null,null,null,null,null,0.66206567348640921,2.5377734066620139E-2,41,16.273555539502603,10.1268886703331,781.81374061717611,791.94062928750918,-2.6645352591003757E-14,10.126888670333074,null,41,1236.8025467639231,2878.7678136302102,4115.5703603941329,224.86631489779256,1461.6688616617157,100,1.9695075192047593,2.8156653455114982,28.787678136302102,41.155703603941326,12.368025467639232,15.384217369326086,84.615782630673905]
[null,null,null,null,null,null,null,0.15613862667185641,0.32386959637598578,42,2.5465057123174319,11.61934798187993,798.08729615667869,809.70664413855866,3.907985046680551E-14,11.619347981879969,null,42,1239.7332365133484,1894.9425155681272,3134.6757520814758,362.72692029717086,1602.4601568105193,100,1.1825208305582802,1.9561645503377911,18.949425155681272,31.346757520814759,12.397332365133485,22.635628022048916,77.36437197795108]
[null,null,null,null,null,null,null,5.3845830658298954E-3,0.98432334626652151,43,8.0986982760289622E-2,14.921616731332607,800.6338018689961,824.62826086989128,9.0728422695625692,23.994459000895176,null,43,1268.970450488586,2005.5855702512472,3274.556020739833,132.57769831249743,1401.5481488010835,100,1.4309787159056013,2.33638496368531,20.055855702512471,32.745560207398327,12.68970450488586,9.4593752220291147,90.540624777970891]
[null,null,null,null,null,null,null,0.36355614576392747,0.31743783383490332,44,6.7778861254626683,11.587189169174517,800.71478885175634,836.21545003906579,23.913472018134932,35.500661187309447,null,44,1266.1015754069178,2061.1470657357104,3327.2486411426285,404.60175411690716,1670.703329523825,100,1.2337002203276675,1.9915257139584102,20.611470657357103,33.272486411426286,12.661015754069178,24.217450636925744,75.782549363074253]
[null,null,null,null,null,null,null,{"$f":"RAND()","v":7.9475110150043271E-2},{"$f":"RAND()","v":0.3760640911959775},45,1.2421685877780597,11.880320455979888,807.49267497721905,848.09577049504571,28.722775061846772,40.603095517826659,null,45,1277.2161156249563,1710.1292880095136,2987.3454036344692,305.49787325937223,1582.7139888843285,100,1.0805043109620844,1.8874827824958318,17.101292880095137,29.873454036344693,12.772161156249563,19.302152846625237,80.697847153374767]
[null,null,null,null,null,null,null,0.21354832816383429,0.45862048726833127,{"$f":"+J50+1","v":46},3.6033600824517622,{"$f":"+$E$7+I51*($G$7-$E$7)","v":12.293102436341655},{"$f":"+M50+K50","v":808.73484356499716},{"$f":"MAX(M51,N50)+L51","v":860.38887293138737},{"$f":"+N51-M51-L51","v":39.360926930048549},{"$f":"+N51-M51","v":51.654029366390205},null,46,1244.7465250798527,1134.4575135818693,2379.2040386617223,661.74790774672033,1906.4944328265731,100,0.59504895165097338,1.2479470161023805,11.344575135818694,23.792040386617224,12.447465250798528,34.710193554859288,65.289806445140712]
[null,null,null,null,null,null,null,{"$f":"RAND()","v":0.13056542043257557},0.92181525500294925,{"$f":"+J51+1","v":47},2.0986828073820432,{"$f":"+$E$7+I52*($G$7-$E$7)","v":14.609076275014747},{"$f":"+M51+K51","v":812.33820364744895},{"$f":"MAX(M52,N51)+L52","v":874.99794920640215},{"$f":"+N52-M52-L52","v":48.050669283938461},{"$f":"+N52-M52","v":62.659745558953205},null,47,1262.1751222459359,1573.5756517496814,2835.7507739956177,303.76637179197564,1565.9414940379115,100,1.0048751232027733,1.810891904194579,15.735756517496814,28.357507739956176,12.621751222459359,19.398321900819461,80.601678099180546]
[null,null,null,null,null,null,null,0.13006309230363511,7.4251368484517855E-2,{"$f":"+J52+1","v":48},2.0900188477865655,{"$f":"+$E$7+I53*($G$7-$E$7)","v":10.371256842422589},{"$f":"+M52+K52","v":814.43688645483098},{"$f":"MAX(M53,N52)+L53","v":885.36920604882471},{"$f":"+N53-M53-L53","v":60.561062751571136},{"$f":"+N53-M53","v":70.932319593993725},null,48,1255.7962409779545,3212.7878736155226,4468.5841145934737,207.99973615348063,1463.7959771314352,100,2.1948331077610579,3.0527369827525059,32.127878736155225,44.685841145934738,12.557962409779545,14.209612500854973,85.790387499145027]
[null,null,null,null,null,null,null,0.43772621967614367,0.13542699521657797,{"$f":"+J53+1","v":49},8.6364959116210631,{"$f":"+$E$7+I54*($G$7-$E$7)","v":10.67713497608289},{"$f":"+M53+K53","v":816.52690530261759},{"$f":"MAX(M54,N53)+L54","v":896.04634102490763},{"$f":"+N54-M54-L54","v":68.842300746207144},{"$f":"+N54-M54","v":79.519435722290041},null,49,1251.6826734488054,1632.4902327005927,2884.1729061493988,572.63521334323377,1824.3178867920392,100,0.89484965559989949,1.580959616210887,16.324902327005926,28.841729061493989,12.516826734488054,31.389003938901279,68.610996061098717]
[null,null,null,null,null,null,null,0.98846606501055057,0.9422907569705169,{"$f":"+J54+1","v":50},66.936925803479028,{"$f":"+$E$7+I55*($G$7-$E$7)","v":14.711453784852583},{"$f":"+M54+K54","v":825.16340121423866},{"$f":"MAX(M55,N54)+L55","v":910.75779480976018},{"$f":"+N55-M55-L55","v":70.882939810668944},{"$f":"+N55-M55","v":85.594393595521524},null,50,1240.3367178224712,1714.2082434795607,2954.5449613020319,508.71461111018357,1749.0513289326548,100,0.98007886625353824,1.6892271326908515,17.142082434795608,29.54544961302032,12.403367178224713,29.085173356268669,70.914826643731331]
[null,null,null,null,null,null,null,{"$f":"RAND()","v":0.79647166077324649},0.76753867787032048,{"$f":"+J55+1","v":51},23.879250370434146,{"$f":"+$E$7+I56*($G$7-$E$7)","v":13.837693389351603},{"$f":"+M55+K55","v":892.10032701771775},{"$f":"MAX(M56,N55)+L56","v":924.59548819911174},{"$f":"+N56-M56-L56","v":18.657467792042393},{"$f":"+N56-M56","v":32.495161181393996},null,51,1233.152004179525,1326.0272835503326,2559.1792877298567,297.8550367846974,1531.0070409642224,100,0.86611442538840688,1.6715659819030586,13.260272835503326,25.591792877298566,12.331520041795249,19.45484434853477,80.545155651465222]
[null,null,null,null,null,null,null,0.16215188174080419,0.64772283122658125,52,2.6537765708103866,13.238614156132906,915.97957738815194,937.83410235524468,8.6159108109598375,21.854524967092743,null,52,1240.4723053048863,2943.0574542751156,4183.5297595800021,84.87997238724347,1325.3522776921297,100,2.2205850503384186,3.156541721016914,29.430574542751156,41.835297595800021,12.404723053048862,6.4043329321504752,93.595667067849533]
[null,null,null,null,null,null,null,0.29060854831588112,0.44520329418039106,53,5.150216801698412,12.226016470901955,918.63335395896229,950.06011882614666,19.200748396282421,31.426764867184374,null,53,1258.9486028581161,1240.8878074297629,2499.8364102878795,512.46175697707758,1771.4103598351937,100,0.70050838335687005,1.4112124818556757,12.408878074297629,24.998364102878796,12.589486028581161,28.929590150119445,71.070409849880562]
[null,null,null,null,null,null,null,0.368931109581492,0.94693253233077523,54,6.9051036873863207,14.734662661653875,923.78357076066072,964.79478148780049,26.276548065485894,41.011210727139769,null,54,1243.2800490295988,2895.6191969858037,4138.8992460154013,73.232811988382082,1316.5128610179809,100,2.1994613822054077,3.1438350270388074,28.956191969858036,41.388992460154014,12.432800490295987,5.5626355166599373,94.437364483340062]
[null,null,null,null,null,null,null,0.90699875330456403,0.40720094163098108,55,35.627135708871947,12.036004708154906,930.6886744480471,976.8307861959554,34.106107039753397,46.142111747908302,null,55,1225.0021672163223,3534.3461501407792,4759.348317357103,46.712593876515484,1271.7147610928378,100,2.7791972368894795,3.7424652626247696,35.343461501407795,47.59348317357103,12.250021672163223,3.6731974264711211,96.32680257352888]
[null,null,null,null,null,null,null,0.73603127961357029,0.74011249070305396,56,19.978869993604011,13.700562453515269,966.31581015691904,990.53134864947071,10.514976039036403,24.215538492551673,null,56,1237.9419793499719,1585.0250090578832,2822.9669884078539,307.89936511394626,1545.8413444639182,100,1.02534779182501,1.8261686417675869,15.850250090578832,28.22966988407854,12.37941979349972,19.917915005742234,80.082084994257769]
[null,null,null,null,null,null,null,0.47347432298924541,0.33616902366195933,57,9.6218276901913846,11.680845118309797,986.29468015052305,1002.2121937677805,4.236668498947644,15.917513617257441,null,57,1277.5861048128336,3560.8374325049008,4838.4235373177344,133.93161235847401,1411.5177171713076,100,2.5227011954485747,3.4278163698957833,35.608374325049006,48.384235373177347,12.775861048128336,9.4884825552791501,90.511517444720852]
[null,null,null,null,null,null,null,0.40641202615668071,0.46553433909161168,58,7.8235477054816362,12.327671695458058,995.91650784071442,1014.5398654632386,6.2956859270661099,18.623357622524168,null,58,1248.8656069773251,2704.8198361876962,3953.6854431650227,321.23890778636246,1570.1045147636876,100,1.7227005022622917,2.5181033529860795,27.048198361876963,39.536854431650227,12.488656069773251,20.45971492762132,79.54028507237868]
[null,null,null,null,null,null,null,1.9830469390127337E-2,0.52154170616762285,59,0.30044597790598565,12.607708530838114,1003.740055546196,1027.1475739940768,10.799809917042648,23.407518447880761,null,59,1233.3551142254478,1143.5519087988537,2376.9070230243024,371.05800313362101,1604.4131173590688,100,0.71275402602117088,1.4814806718464075,11.435519087988537,23.769070230243024,12.333551142254478,23.127335417476395,76.872664582523612]
[null,null,null,null,null,null,null,5.1905353570180335E-2,0.85457855373322333,60,0.79951415556687611,14.272892768666116,1004.040501524102,1041.420466762743,23.107072469974916,37.379965238641034,null,60,1254.0072853656479,1613.8622752074457,2867.8695605730954,321.78796824045162,1575.7952536060995,100,1.0241573399299384,1.8199506274753476,16.138622752074458,28.678695605730955,12.540072853656479,20.4206712454592,79.579328754540796]
[null,null,null,null,null,null,null,0.12996015185539445,0.4868608950922626,61,2.08824398876017,12.434304475461314,1004.8400156796688,1053.8547712382042,36.580451083074081,49.014755558535398,null,61,1270.4032181864141,3181.0314555087971,4451.4346736952111,234.44972523390811,1504.8529434203222,100,2.1138487115417095,2.9580529400950746,31.81031455508797,44.514346736952113,12.704032181864141,15.579577144663476,84.420422855336525]
[null,null,null,null,null,null,null,0.62705165414479169,3.8494768706923588E-2,62,14.794730278348204,10.192473843534618,1006.928259668429,1064.0472450817388,46.926511569775201,57.118985413309815,null,62,1229.1647910762072,1409.9359268141791,2639.1007178903865,380.52944955571616,1609.6942406319233,100,0.87590294555609238,1.6395043550968695,14.099359268141791,26.391007178903866,12.291647910762071,23.639859045922311,76.360140954077693]
[null,null,null,null,null,null,null,0.79060059936219651,0.16092025965824108,63,23.452677642501715,10.804601298291205,1021.7229899467771,1074.8518463800299,42.324255134961533,53.128856433252736,null,63,1240.1700633377616,791.68193428259565,2031.8519976203565,503.44992976901221,1743.6199931067738,100,0.45404499685277211,1.1653066640971537,7.9168193428259563,20.318519976203564,12.401700633377615,28.873833275561811,71.126166724438193]
[null,null,null,null,null,null,null,0.297030924982157,0.47154041251341605,64,5.2866356723453158,12.35770206256708,1045.1756675892789,1087.209548442597,29.676178790751045,42.033880853318124,null,64,1261.9891863954058,948.38792705022058,2210.3771134456265,434.65313415665696,1696.6423205520628,100,0.55897929431680626,1.3027949890619266,9.4838792705022055,22.103771134456267,12.619891863954058,25.618430525487963,74.381569474512034]
[null,null,null,null,null,null,null,0.86523645131129989,0.26386722297289111,65,{"$f":"-$D$6*LN(1-H70)","v":30.063502910889138},11.319336114864456,1050.4623032616241,1098.5288845574614,36.74724518097284,48.066581295837295,null,65,1246.8892717609206,1364.6143508119346,2611.5036225728563,410.99897948456601,1657.8882512454866,100,0.82310393947648142,1.5751988233289953,13.646143508119346,26.115036225728563,12.468892717609206,24.790511614748674,75.209488385251319]
[null,null,null,null,null,null,null,0.81988460865441726,0.53430345495607856,66,25.712363556810615,12.671517274780392,1080.5258061725133,1111.2004018322418,18.003078384948147,30.674595659728539,null,66,1272.0496408745505,4824.2159741886244,6096.2656150631738,94.62425442895028,1366.6738953035008,100,3.5298954569680272,4.4606585638407621,48.24215974188624,60.962656150631737,12.720496408745506,6.923689312726415,93.07631068727359]
[null,null,null,null,null,null,null,0.49463612751596353,0.86901762970628205,67,10.237148543976552,14.34508814853141,1106.238169729324,1125.5454899807733,4.9622321029178451,19.307320251449255,null,{"$f":"+R71+1","v":67},1254.8297447690522,1788.8768421323086,3043.7065869013609,340.27584558979811,1595.1055903588503,100,1.1214786362386615,1.9081536703890676,17.888768421323086,30.437065869013608,12.548297447690523,21.332496584959394,78.667503415040613]
[null,null,null,null,null,null,null,0.72762179250756365,0.70439382930165428,68,19.508455646556033,13.521969146508273,1116.4753182733004,1139.0674591272816,9.0701717074728911,22.592140853981164,null,68,1253.7635019366389,1021.393348777243,2275.1568507138818,566.68025409944107,1820.44375603608,100,0.56106833588820837,1.2497814574990855,10.213933487772429,22.751568507138817,12.537635019366389,31.128687838912271,68.871312161087729]
[null,null,null,null,null,null,null,1.5115604433912244E-2,0.90058068235727973,69,0.22846514408059468,14.502903411786399,1135.9837739198565,1153.5703625390679,3.083685207424999,17.586588619211398,null,69,1234.1919605308624,1543.7678947705606,2777.9598553014248,312.95824165389831,1547.1502021847607,100,0.99781384676844953,1.7955333951277737,15.437678947705606,27.77959855301425,12.341919605308624,20.228045164067712,79.771954835932291]
[null,null,null,null,null,null,null,2.7422651474315662E-2,0.39939429162116646,70,0.41708506339917051,11.996971458105833,1136.2122390639372,1165.5673339971738,17.358123475130782,29.355094933236614,null,70,1274.1216242720643,2147.6118958856778,3421.7335201577398,386.22200267889434,1660.3436269509587,100,1.2934743513483016,2.0608586467377137,21.476118958856777,34.217335201577399,12.741216242720643,23.261570461058671,76.738429538941332]
[null,null,null,null,null,null,null,0.53916358418661925,0.71438976253873177,71,11.620682180252487,13.571948812693659,1136.6293241273363,1179.1392828098674,28.938009869837419,42.509958682531078,null,71,1259.8578998630048,3360.4079081785871,4620.2658080415931,275.36374641912312,1535.2216462821279,100,2.1888747571508933,3.0095105936205164,33.604079081785869,46.202658080415929,12.598578998630048,17.93641635303776,82.063583646962229]
[null,null,null,null,null,null,null,0.17133756776123066,0.97916448460008532,72,2.8191360828258856,14.895822423000427,1148.2500063075888,1194.0351052328679,30.889276502278619,45.785098925279044,null,72,1248.7902368180437,2184.5026863899266,3433.2929232079696,360.54124518487561,1609.3314820029193,100,1.3573975969644045,2.133365911002381,21.845026863899264,34.332929232079692,12.487902368180437,22.403168596202335,77.596831403797665]
[null,null,null,null,null,null,null,0.84960167162894074,0.49552618580863561,73,28.41701973123438,12.477630929043178,1151.0691423904148,1206.5127361619111,42.965962842453173,55.443593771496353,null,73,1243.8480256475157,2368.8041779680048,3612.6522036155206,287.76715973650676,1531.6151853840224,100,1.5466053095928751,2.3587205442271189,23.688041779680049,36.126522036155208,12.438480256475156,18.788476536575654,81.211523463424356]
[null,null,null,null,null,null,null,0.77867273347902732,0.14868564866856615,74,22.621692432694381,10.74342824334283,1179.4861621216492,1217.2561644052539,27.026574040261924,37.770002283604754,null,74,1252.8611604917378,7320.508263023723,8573.3694235154617,0,1252.8611604917378,100,5.8430323278203335,6.8430323278203344,73.205082630237229,85.733694235154616,12.528611604917378,0,100]
[null,null,null,null,null,null,null,9.4096194182834103E-2,0.63427034283643502,75,1.4823322975622795,13.171351714182176,1202.1078545543435,1230.4275161194362,15.148309850910525,28.319661565092701,null,75,1260.2704858441366,2682.5545445500893,3942.8250303942245,187.62978495601055,1447.9002708001472,100,1.8527205213295803,2.7231330153804842,26.825545445500893,39.428250303942242,12.602704858441365,12.958750594909516,87.041249405090483]
[null,null,null,null,null,null,null,0.53849879356958374,0.21600114343062993,76,11.59905916338349,11.080005717153149,1203.5901868519059,1241.5075218365894,26.837329267530372,37.917334984683521,null,76,1254.8310247033639,1358.4117813277226,2613.2428060310858,536.59250106250283,1791.4235257658668,100,0.75828622421767977,1.4587520865083403,13.584117813277226,26.132428060310858,12.548310247033639,29.953413770933906,70.046586229066094]
[null,null,null,null,null,null,null,0.1008302971407784,0.51487178669715306,77,1.594252407747373,12.574358933485765,1215.1892460152894,1254.081880770075,26.318275821299839,38.892634754785604,null,77,1258.6605528939178,3888.5315722832611,5147.1921251771792,268.75927133951336,1527.4198242334312,100,2.5458171424708365,3.3698607570190529,38.885315722832608,51.471921251771789,12.586605528939179,17.595638545178371,82.404361454821625]
[null,null,null,null,null,null,null,0.86638844900616907,0.34212447392893119,78,30.192278431235088,11.710622369644657,1216.7834984230367,1265.7925031397197,37.298382347038313,49.009004716682966,null,78,1232.6269808078564,4612.442428555526,5845.0694093633811,83.324862714194524,1315.9518435220509,100,3.50502372200084,4.4417046399809514,46.124424285555257,58.450694093633814,12.326269808078564,6.3319082019887212,93.668091798011275]
[null,null,null,null,null,null,null,3.7246160416959384E-3,2.1401753584733063E-2,79,5.5973545437841596E-2,10.107008767923665,1246.9757768542718,1275.8995119076433,18.816726285447835,28.923735053371502,null,79,1263.1641515593953,2212.7274868339919,3475.891638393387,106.94281762985656,1370.1069691892519,100,1.6150034534481295,2.5369490970841597,22.127274868339917,34.758916383933872,12.631641515593953,7.8054356363969877,92.194564363603021]
[null,null,null,null,null,null,null,6.2176168570432511E-3,0.73152680305863316,80,9.355540101017186E-2,13.657634015293166,1247.0317503997096,1289.5571459229363,28.867761507933569,42.525395523226734,null,80,1239.9623353163668,3949.9639758148492,5189.9263111312148,66.66122072181679,1306.6235560381836,100,3.0230313524972292,3.9720134289233258,39.49963975814849,51.899263111312145,12.399623353163667,5.1017923573902522,94.898207642609748]
[null,null,null,null,null,null,null,0.73815741696643544,0.983986051177134,81,20.100176758601247,14.919930255885671,1247.1253058007198,1304.477076178822,42.431840122216499,57.351770378102174,null,81,1252.7326571715296,1881.3640597940384,3134.0967169655678,505.3261738144156,1758.0588309859452,100,1.0701371459446223,1.7827029799724736,18.813640597940385,31.340967169655677,12.527326571715296,28.743416597214853,71.256583402785139]
[null,null,null,null,null,null,null,0.19162038845169571,0.80492120364182906,82,3.1908527177624695,14.024606018209145,1267.2254825593211,1318.5016821970312,37.251593619500937,51.276199637710079,null,82,1254.2777414677355,4462.828902934406,5717.1066444021426,267.38550802609097,1521.6632494938265,100,2.9328623822773818,3.7571431434017408,44.62828902934406,57.171066444021427,12.542777414677355,17.571923887564179,82.428076112435818]
[null,null,null,null,null,null,null,3.6379304377662458E-2,6.2103572766141202E-2,83,0.55586296608556029,10.310517863830706,1270.4163352770836,1328.8122000608619,48.085346919947575,58.395864783778279,null,83,1243.1285617436774,1469.4978370188137,2712.6263987624907,363.23103609055215,1606.3595978342296,100,0.91480004788470815,1.6886794229758908,14.694978370188137,27.126263987624906,12.431285617436775,22.612062490881712,77.387937509118288]
[null,null,null,null,null,null,null,0.22063201533103416,0.39714761866838022,84,3.7390794572252273,11.985738093341901,1270.9721982431693,1340.7979381542038,57.840001817692688,69.825739911034589,null,84,1257.8846210311463,4407.6724027358678,5665.5570237670163,146.5297062637087,1404.414327294855,100,3.1384416386763925,4.0341065408239318,44.076724027358679,56.655570237670162,12.578846210311463,10.43350978524623,89.56649021475377]
[null,null,null,null,null,null,null,0.54756096563799428,0.89608791053772874,85,11.896533834162769,14.480439552688644,1274.7112777003945,1355.2783777068926,66.086660453809458,80.567100006498094,null,85,1238.852692562542,2786.000173216758,4024.8528657792986,176.76808936889097,1415.6207819314329,100,1.9680413065253382,2.8431716439539008,27.860001732167579,40.248528657792988,12.38852692562542,12.486966257143639,87.513033742856365]
[null,null,null,null,null,null,null,0.49908075702636767,0.61710402465093328,86,10.369655738391634,13.085520123254666,1286.6078115345572,1368.3638978301472,68.670566172335299,81.756086295589967,null,86,1265.9636320942909,1925.4982363200106,3191.4618684143015,457.34280420706591,1723.3064363013568,100,1.1173278273437006,1.851941013615646,19.254982363200106,31.914618684143015,12.659636320942909,26.538681372805467,73.46131862719453]
[null,null,null,null,null,null,null,0.73549177096212104,0.74898670462510786,87,19.94824374740011,13.744933523125539,1296.9774672729488,1382.1088313532728,71.386430557198381,85.13136408032392,null,87,1242.0365669593027,1525.4710232725517,2767.5075902318554,363.3986308790636,1605.4351978383663,100,0.95019158999785103,1.7238363740611631,15.254710232725518,27.675075902318554,12.420365669593027,22.635521593668848,77.364478406331145]
[null,null,null,null,null,null,null,0.85077074721167811,0.21617646779572786,88,28.534073192485057,11.08088233897864,1316.9257110203489,1393.1897136922514,65.183120332923878,76.264002671902517,null,88,1248.2893198524857,766.62130996469068,2014.9106298171764,445.6079462255409,1693.8972660780266,100,0.45257839735445771,1.1895117078041042,7.6662130996469067,20.149106298171763,12.482893198524858,26.306668955035356,73.693331044964637]
[null,null,null,null,null,null,null,0.59417454786941926,2.2695936629950508E-2,89,13.527481990252687,10.113479683149752,1345.4597842128339,1403.3031933754012,47.729929479417493,57.843409162567241,null,89,1268.1946988372179,1325.27396229236,2593.4686611295792,328.56841592890282,1596.7631147661207,100,0.82997531070003083,1.6242037639436873,13.252739622923601,25.934686611295792,12.681946988372179,20.577154675634436,79.422845324365568]
[null,null,null,null,null,null,null,0.17065286700788762,0.99167467984597701,90,2.8067471170450258,14.958373399229885,1358.9872662030866,1418.2615667746311,44.315927172314588,59.274300571544472,null,90,1248.4129141707172,3159.6083284557499,4408.0212426264661,190.89604040645349,1439.3089545771707,100,2.1952259231124951,3.0625955800583631,31.596083284557498,44.080212426264659,12.484129141707172,13.263034305413148,86.736965694586857]
[null,null,null,null,null,null,null,0.85177294573526052,0.75858545055938575,91,28.635150455807363,13.792927252796929,1361.7940133201316,1432.0544940274281,56.467553454499509,70.260480707296438,null,91,1259.4958760833015,1351.2755304655518,2610.7714065488531,240.5927712630903,1500.0886473463918,100,0.900797118127595,1.7404114157968085,13.512755304655519,26.10771406548853,12.594958760833014,16.038570233078634,83.96142976692137]
[null,null,null,null,null,null,null,0.3432021821234662,0.76423137127465268,92,6.3056856480826013,13.821156856373264,1390.4291637759391,1445.8756508838014,41.625330251489103,55.446487107862367,null,92,1269.6058239760246,1289.5754983340826,2559.1813223101071,297.11738140417879,1566.7232053802034,100,0.82310359220162044,1.6334610437387755,12.895754983340826,25.59181322310107,12.696058239760246,18.964254846284483,81.035745153715524]
[null,null,null,null,null,null,null,0.65119787079903257,0.74353190947203729,93,15.798757239080585,13.717659547360187,1396.7348494240216,1459.5933104311616,49.140801459779837,62.858461007140022,null,93,1234.5664918160819,4435.0612312974527,5669.6277231135364,392.43304218957292,1626.9995340056548,100,2.7259142603307214,3.4847137965399262,44.350612312974526,56.696277231135362,12.34566491816082,24.1200463790796,75.879953620920404]
[null,null,null,null,null,null,null,0.54004765908356289,0.32658881814434171,94,11.649486023549088,11.632944090721708,1412.5336066631021,1471.2262545218832,47.059703768059421,58.692647858781129,null,94,1267.5098033109728,1555.7969018937015,2823.3067052046745,236.30768681998529,1503.817490130958,100,1.0345649735449061,1.8774264322187197,15.557969018937015,28.233067052046746,12.675098033109727,15.713854132618629,84.286145867381364]
[null,null,null,null,null,null,null,0.44788353412182957,0.85758642936291096,95,8.909943990755135,14.287932146814555,1424.1830926866512,1485.5141866686977,47.043161835231913,61.331093982046468,null,95,1259.9516056424504,2071.6172778841928,3331.5688835266433,137.73097059709085,1397.6825762395413,100,1.4821800837339405,2.3836377015518178,20.71617277884193,33.315688835266435,12.599516056424504,9.854238218212279,90.145761781787726]
[null,null,null,null,null,null,null,0.88776737791008498,0.10155234034258609,96,32.807723680327385,10.50776170171293,1433.0930366774064,1496.0219483704107,52.421149991291308,62.928911693004238,null,96,1254.9955760287305,3482.3645590081996,4737.3601350369318,132.25833448418416,1387.2539105129147,100,2.5102575185537965,3.4149192870434004,34.823645590081995,47.37360135036932,12.549955760287306,9.5338231510397247,90.466176848960274]
[null,null,null,null,null,null,null,0.79916564207155361,0.7892516718206658,97,24.079122008700676,13.946258359103329,1465.9007603577338,1509.9682067295139,30.12118801267675,44.067446371780079,null,97,1232.4346693255777,1512.5520479708885,2744.9867172964664,435.6959312520587,1668.1306005776364,100,0.90673478889909787,1.6455466474543052,15.125520479708884,27.449867172964662,12.324346693255777,26.11881414447927,73.881185855520727]
[null,null,null,null,null,null,null,6.1851473084666431E-2,0.56900306957138558,98,0.95770497377435915,12.845015347856927,1489.9798823664346,1522.8132220773707,19.988324363079187,32.833339710936116,null,98,1259.1129370358294,1355.9407899485154,2615.0537269843453,377.71961531877173,1636.8325523546011,100,0.82839309860863908,1.5976305720597763,13.559407899485155,26.150537269843454,12.591129370358294,23.076252654886293,76.923747345113696]
[null,null,null,null,null,null,null,0.91897929982016036,0.59202694913726284,99,37.695758987748398,12.960134745686315,1490.9375873402089,1535.7733568230569,31.875634737161722,44.835769482848036,null,99,1231.0923472838604,1792.2208459851822,3023.3131932690439,301.75802282310178,1532.8503701069621,100,1.1692079546290752,1.9723472376877056,17.922208459851824,30.233131932690441,12.310923472838603,19.686071694137055,80.313928305862945]
[null,null,null,null,null,null,null,5.1801457006682261E-2,0.23936611014189457,100,0.79787047677002854,11.196830550709473,1528.6333463279573,1546.9701873737663,7.1400104950995509,18.336841045809024,null,100,1245.8760726534679,1031.2148558125039,2277.090928465971,631.02619911479815,1876.902271768266,100,0.54942384125358656,1.2132176313690961,10.312148558125038,22.770909284659709,12.458760726534679,33.620620988449026,66.379379011550981]

{"sheet":"Sheet3","index":2,"n_rows":50,"n_cols":23,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[null,"Exemplo 5 - Simulação"]
[]
[null,"Chegada Exponencial de média",null,null,15]
[null,"Serviço Uniforme de min - máx","min-max",null,10,15]
[]
[null,"Nº Clientes",10]
[null,null,null,null,null,null,"Próx.",null,"Próx.","Próxima","Próxima","Próximo","Tempo",null,"NPA ","NPA ","Nº","Intervalo","Tempo ","Tempo","Tempo","Tempo","Tempo "]
[null,"Cliente Ch.","Cliente Nº","T. Simul.","Nº Clientes","NPA Ch","Int. CH","NPA Par","T. Serv.","Chegada","Partida","Acontec.","Espera",null,"Chegadas","Seviço","Clientes","Chegadas","Serviço","Chegada","Partida","Fila","Sistema"]
[null,1,{"$f":"SUM($B$9:B9)","v":1},0,1,{"$f":"RAND()","v":0.5972793486657324},{"$f":"-$E$3*LN(F9)","v":7.7305553147576074},{"$f":"RAND()","v":0.16093336719691331},{"$f":"$E$4+H9*($F$4-$E$4)","v":10.804666835984566},{"$f":"+D9+G9","v":7.7305553147576074},{"$f":"+D9+I9","v":10.804666835984566},{"$f":"IF(J9<K9,\"chegada\",\"partida\")","v":"chegada"},{"$f":"IF(E9<2,0,(E9-1)*(D10-D9))","v":0},null,{"$f":"RAND()","v":0.93687522931562262},{"$f":"RAND()","v":0.52356709549467972},1,{"$f":"-$E$3*LN(O9)","v":0.97807748038194586},{"$f":"$E$4+P9*($F$4-$E$4)","v":12.617835477473399},0,{"$f":"+T9+S9","v":12.617835477473399},{"$f":"+U9-T9-S9","v":0},{"$f":"+U9-T9","v":12.617835477473399}]
[null,{"$f":"IF(SUM(E9:L9)=0,0,IF(L9=\"partida\",0,1))","v":1},{"$f":"SUM($B$9:B10)","v":2},{"$f":"IF(L9=\"partida\",K9,J9)","v":7.7305553147576074},{"$f":"IF(L9=\"partida\",E9-1,E9+1)","v":2},{"$f":"IF(L9=\"partida\", 0,RAND())","v":0.84662322505130361},{"$f":"IF(F10=0,0,-$E$3*LN(F10))","v":2.497492769228089},{"$f":"IF(L9=\"partida\",IF(E10=0,0,RAND()),IF(E10>1,0,RAND()))","v":0},{"$f":"IF(H10=0,0,$E$4+H10*($F$4-$E$4))","v":0},{"$f":"IF(C10=$C$6,0,+J9+G10)","v":10.228048083985696},{"$f":"IF(D10<K9,K9,IF(I10=0,0,D10+I10))","v":10.804666835984566},{"$f":"IF(C10<$C$6,IF(C10=$C$6,\"partida\",IF(K10=0,\"chegada\",IF(J10<K10,\"chegada\",\"partida\"))),IF(E10=0,0,IF(C10=$C$6,\"partida\",IF(K10=0,\"chegada\",IF(J10<K10,\"chegada\",\"partida\")))))","v":"chegada"},2.4974927692280886,null,{"$f":"RAND()","v":0.78112589716531267},{"$f":"RAND()","v":0.57527297519353082},{"$f":"+Q9+1","v":2},{"$f":"-$E$3*LN(O10)","v":3.7052841326727273},{"$f":"$E$4+P10*($F$4-$E$4)","v":12.876364875967655},{"$f":"+T9+R9","v":0.97807748038194586},{"$f":"MAX(T10,U9)+S10","v":25.494200353441052},11.639757997091452,24.516122873059107]
[null,1,{"$f":"SUM($B$9:B11)","v":3},10.228048083985696,{"$f":"IF(L10=\"partida\",E10-1,E10+1)","v":3},{"$f":"IF(L10=\"partida\", 0,RAND())","v":0.4625677720738598},11.564432978264932,0,0,21.79248106225063,10.804666835984566,"partida",1.1532375039977403,null,{"$f":"RAND()","v":0.23036956422956112},0.85945541701586048,3,22.021056878766299,14.297277085079301,{"$f":"+T10+R10","v":4.6833616130546734},{"$f":"MAX(T11,U10)+S11","v":39.791477438520353},20.81083874038638,35.108115825465681]
[null,0,{"$f":"SUM($B$9:B12)","v":3},10.804666835984566,{"$f":"IF(L11=\"partida\",E11-1,E11+1)","v":2},{"$f":"IF(L11=\"partida\", 0,RAND())","v":0},0,0.80013880040271279,14.000694002013564,21.79248106225063,24.80536083799813,"chegada",10.987814226266064,null,0.19421565322559309,0.60296880944834341,4,24.58179184109818,13.014844047241716,26.704418491820974,52.806321485762069,13.087058946699379,26.101902993941096]
[null,1,{"$f":"SUM($B$9:B13)","v":4},21.79248106225063,{"$f":"IF(L12=\"partida\",E12-1,E12+1)","v":3},{"$f":"IF(L12=\"partida\", 0,RAND())","v":0.63186056691860648},6.8862979671017328,0,0,28.678779029352363,24.80536083799813,"partida",6.0257595514949998,null,0.56201698766154851,0.76335856459519036,5,8.6433480358424539,13.816792822975952,51.286210332919154,66.623114308738025,1.5201111528429188,15.336903975818871]
[null,0,{"$f":"SUM($B$9:B14)","v":4},24.80536083799813,{"$f":"IF(L13=\"partida\",E13-1,E13+1)","v":2},{"$f":"IF(L13=\"partida\", 0,RAND())","v":0},0,0.55065542339698059,12.753277116984902,28.678779029352363,37.558637954983034,"chegada",3.8734181913542329,null,0.7148765490309299,8.0305546674427797E-2,6,5.0346811484003764,10.40152773337214,59.929558368761604,77.024642042110159,6.6935559399764148,17.095083673348554]
[null,1,{"$f":"SUM($B$9:B15)","v":5},28.678779029352363,{"$f":"IF(L14=\"partida\",E14-1,E14+B15)","v":3},{"$f":"IF(C15=$C$6,0, RAND())","v":0.16245292902135799},27.260504801024553,0,0,55.939283830376915,37.558637954983034,"partida",17.759717851261343,null,8.2528591557452846E-2,0.53610534914275398,7,37.419157220224307,12.68052674571377,64.964239517161985,89.705168787823936,12.060402524948181,24.740929270661951]
[null,0,{"$f":"SUM($B$9:B16)","v":5},37.558637954983034,2,0.22571403191401973,22.327296396729423,0.33770429956619585,11.68852149783098,78.266580227106346,49.247159452814017,"partida",11.688521497830983,null,0.2647373557809064,0.11390868216185834,8,19.935255820967754,10.569543410809292,102.38339673738629,112.95294014819558,0,10.569543410809288]
[null,0,{"$f":"SUM($B$9:B17)","v":5},49.247159452814017,1,0.74231246172375975,4.4697752551678844,0.93996474114415274,14.699823705720764,82.736355482274234,63.946983158534778,"partida",0,null,0.48531394840736986,0.59495914803724592,9,10.844389217394427,12.974795740186229,122.31865255835405,135.29344829854028,0,12.974795740186238]
[null,0,{"$f":"SUM($B$9:B18)","v":5},63.946983158534778,0,0.35711455803521097,15.445479867330363,{"$f":"IF(L17=0,0,IF(L17=\"partida\",IF(E18=0,0,RAND()),IF(E18>1,0,RAND())))","v":0},0,98.181835349604597,0,"chegada",0,null,0.32189980331787038,0.24999528364805301,10,17.002724275220718,11.249976418240266,133.16304177574847,146.54342471678055,2.1304065227918159,13.380382941032082]
[null,1,{"$f":"SUM($B$9:B19)","v":6},98.181835349604597,1,0.19634799920734647,24.418000319092751,0.89038500493023609,14.451925024651182,122.59983566869735,112.63376037425579,"partida",0]
[null,0,{"$f":"SUM($B$9:B20)","v":6},112.63376037425579,0,0.28908334967334781,18.615603379152681,0,0,141.21543904785003,0,"chegada",0]
[null,1,{"$f":"SUM($B$9:B21)","v":7},141.21543904785003,1,0.71948593515319026,4.9382745139544628,0.28222689616900964,11.411134480845048,146.15371356180449,152.62657352869508,"chegada",0]
[null,1,{"$f":"SUM($B$9:B22)","v":8},146.15371356180449,2,0.97887425981619858,0.32028123103428868,0,0,146.47399479283879,152.62657352869508,"chegada",0.32028123103430062]
[null,1,{"$f":"SUM($B$9:B23)","v":9},146.47399479283879,3,0.99613419376732815,5.8099466625794703E-2,0,0,146.5320942594646,152.62657352869508,"chegada",0.11619893325161001]
[null,1,{"$f":"SUM($B$9:B24)","v":10},146.5320942594646,4,0,0,0,0,0,152.62657352869508,"partida",18.283437807691428]
[null,0,{"$f":"SUM($B$9:B25)","v":10},152.62657352869508,3,0,0,4.6806341229670312E-2,10.234031706148352,0,162.86060523484343,"partida",20.468063412296715]
[null,0,{"$f":"SUM($B$9:B26)","v":10},162.86060523484343,2,0,0,0.69363962553585146,13.468198127679258,0,176.32880336252271,"partida",13.468198127679273]
[null,0,{"$f":"SUM($B$9:B27)","v":10},176.32880336252271,1,0,0,1.6310868289670544E-2,10.081554341448353,0,186.41035770397104,"partida",0]
[null,0,{"$f":"SUM($B$9:B28)","v":10},186.41035770397104,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B29)","v":10},0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B30)","v":10},0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B31)","v":10},0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B32)","v":10},0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"SUM($B$9:B33)","v":10},0,0,0,{"$f":"-15*LN(1-F33)","v":0},0,0,0,0,0,0]
[]
[]
[null,null,null,null,"Medidas de Performance",null,null,null,null,null,null,null,null,null,null,null,null,"Medidas de Performance"]
[]
[null,null,"Tempo Total de Simulação",null,null,null,{"$f":"MAX(D9:D33)","v":186.41035770397104},"minutos",null,null,null,null,null,null,null,"Tempo Total de Simulação",null,null,null,null,{"$f":"MAX(U9:U33)","v":146.54342471678055},"minutos"]
[null,null,"Tempo de Actividade (Serviço)",null,null,null,{"$f":"SUM(I9:I29)","v":123.59382683930698},"\"",null,null,null,null,null,null,null,"Tempo Total de Actividade (Serviço)",null,null,null,null,{"$f":"SUM(S9:S33)","v":124.49948435705971},"\""]
[null,null,"Tempo Total na Fila",null,null,null,{"$f":"SUM(M9:M29)","v":106.64214110338678},"\"",null,null,null,null,null,null,null,"Tempo Total na Fila",null,null,null,null,{"$f":"SUM(V9:V9:V33)","v":67.942131824736535},"\""]
[null,null,"Tempo no Sistema",null,null,null,{"$f":"+G40+G39","v":230.23596794269378},"\"",null,null,null,null,null,null,null,"Tempo Total no Sistema",null,null,null,null,{"$f":"SUM(W9:W10:W33)","v":192.44161618179629},"\""]
[null,null,"Tempo de Inactividade",null,null,null,{"$f":"+G38-G39","v":62.81653086466406},"\"",null,null,null,null,null,null,null,"Tempo Total de Inactividade",null,null,null,null,{"$f":"+U38-U39","v":22.043940359720835},"\""]
[]
[null,null,"Comprimento médio da Fila",null,null,null,{"$f":"+G40/D18","v":1.6676649286019309},"clientes",null,null,null,null,null,null,null,"Compriento médio fila",null,null,null,null,{"$f":"+U40/U38","v":0.46363139087301913},"clientes"]
[null,null,"Nº médio clientes no Sistema",null,null,null,{"$f":"+G41/D18","v":3.6004195439822713},"\"",null,null,null,null,null,null,null,"Nº médio Clientes no Sistema",null,null,null,null,{"$f":"+U41/U38","v":1.3132053966510036},"\""]
[null,null,"Tempo médio na Fila",null,null,null,{"$f":"+G40/MAX(C9:C33)","v":10.664214110338678},"\"",null,null,null,null,null,null,null,"Tempo médio na fila",null,null,null,null,{"$f":"+U40/MAX(Q9:Q33)","v":6.7942131824736531},"minutos"]
[null,null,"Tempo médio no Sistema",null,null,null,{"$f":"+G41/MAX(C9:C33)","v":23.023596794269377},"\"",null,null,null,null,null,null,null,"Tempo médio no Sistema",null,null,null,null,{"$f":"+U41/MAX(Q9:Q33)","v":19.244161618179628},"\""]
[]
[null,null,"% Utilização média do Serviço",null,null,null,{"$f":"+G39/G38*100","v":66.302016884480281}," %",null,null,null,null,null,null,null,"%Utilização do Sistema",null,null,null,null,{"$f":"+U39/U38*100","v":84.957400577798424},"%"]
[null,null,"% Inactividade do Sistema",null,null,null,{"$f":"+G42/G38*100","v":33.697983115519712},"%",null,null,null,null,null,null,null,"% Inactividade do Sistema",null,null,null,null,{"$f":"+U42/U38*100","v":15.042599422201578},"%"]